﻿CREATE TYPE [dbo].[udtPersOrg] AS TABLE (
    [OrgKey]         INT           NOT NULL,
    [PersKey]        INT           NOT NULL,
    [FunktionsKey]   INT           NULL,
    [BerufstitelKey] INT           NULL,
    [Durchwahl]      NVARCHAR (50) NULL,
    [Fax]            NVARCHAR (50) NULL,
    [Tätigkeit]      NVARCHAR (50) NULL,
    PRIMARY KEY CLUSTERED ([OrgKey] ASC, [PersKey] ASC));




GO
GRANT TAKE OWNERSHIP
    ON TYPE::[dbo].[udtPersOrg] TO PUBLIC
    AS [dbo];


GO
GRANT REFERENCES
    ON TYPE::[dbo].[udtPersOrg] TO PUBLIC
    AS [dbo];


GO
GRANT CONTROL
    ON TYPE::[dbo].[udtPersOrg] TO PUBLIC
    AS [dbo];

